﻿CREATE TABLE [dbo].[LogEvent] (
    [LogEventRowId]  INT           IDENTITY (1, 1) NOT NULL,
    [RoleRowId]      SMALLINT      NOT NULL,
    [DateTimeUTC]    DATETIME      NOT NULL,
    [EventNumber]    SMALLINT      NOT NULL,
    [EventLevel]     TINYINT       NOT NULL,
    [InstanceNumber] SMALLINT      NOT NULL,
    [Message]        VARCHAR (MAX) NOT NULL,
    CONSTRAINT [PK_LogEvent] PRIMARY KEY CLUSTERED ([LogEventRowId] ASC)
);

